﻿CREATE PROCEDURE [dbo].[SystemUser_Select]
@SystemUserID uniqueidentifier
AS
BEGIN

SELECT [SystemUserID]
, [CreatedDate]
, [CreatedBy]
, [ModifiedDate]
, [ModifiedBy]
, [Deleted]
, [EmployeeID]
, [UserName]
, [Salt]
, [Password]
, [LastLoginDate]
, [LastPasswordChangeDate]
, [NextPasswordChangeDate]
, [ApprovedBy]
, [ApprovedDate]
, [IsApproved]
, [IsLoggedOn]
, [IsLockedOut]
FROM [dbo].[SystemUser] (NoLock)
WHERE [Deleted] = 0
AND [SystemUserID] = @SystemUserID


END
